<%--
  Created by IntelliJ IDEA.
  User: 36061
  Date: 2024/9/25
  Time: 10:49
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@page import="java.sql.*" %>
<% request.setCharacterEncoding("UTF-8");%>
<% String id = request.getParameter("stuid");%>
<% String stuName = request.getParameter("stuname");%>
<% String stuBirthday = request.getParameter("date");%>
<% String stuClass = request.getParameter("stuclass");%>
<html>
<head>
    <title>4-5更新页面完成更新操作</title>
    <%! ResultSet rs;%>
    <%
        String dbName = "school";//数据库
        String userName ="root";//账户
        String userPassword ="qwert";//密码
        String url ="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPassword;
        Class.forName("com.mysql.cj.jdbc.Driver");//5.7以下不加.cj
        Connection conn = DriverManager.getConnection(url);//连接数据库
        String sql = "update student set birthday=?,stuclass=?where number=?";
        PreparedStatement preparedStatement= conn.prepareStatement(sql);//创建操作对象
       preparedStatement.setString(1,stuBirthday);
       preparedStatement.setString(2,stuClass);
       preparedStatement.setString(3,id);
        int rsult = preparedStatement.executeUpdate();//运行sql命令查询数据 结果放到rs结果集中
        if (rsult>0){
            out.print("<script type='text/javascript'>alert('修改成功')</script>");
        }else {
            out.print("<script type='text/javascript'>alert('修改失败')</script>");
        }
        sql = "select  * from student";
        rs = preparedStatement.executeQuery(sql);
    %>

</head>
<body>
<table border="1">
<th colpan="4" style="font-size: x-large;alignment:center">学生表信息</th>
<tr style="text-align: center">
    <td>学号</td>
    <td>姓名</td>
    <td>出生日期</td>
    <td>所在班级</td>
</tr>
    <% while (rs.next()){%>
<tr style="text-align: center">
    <td><%=rs.getString(1) %></td>
    <td><%=rs.getString(2) %></td>
    <td><%=rs.getString(3) %></td>
    <td><%=rs.getString(4) %></td>
</tr>
    <% } %>
    <%
        rs.close();
        preparedStatement.close();
        conn.close();
    %>
</table>
</body>
</html>
